Syntax error in partial filter expression on table <name>. (Error 3586)

Make sure you are using the correct syntax in the expression.